.. _`Unique Table`:

.. _`org.sysess.sympathy.data.table.uniquetable`:

Unique Table
````````````

.. image:: unique_table.svg
   :width: 48


For each unique value in selected columns only keep the first row with that value. When multiple columns are selected, unique combinations of values are considered.




Documentation
:::::::::::::

The Table in the output will have no more rows than the incoming Table.


Definition
::::::::::


Input ports
...........

    **Input**
        | Type: table
        | Description: Input

Output ports
............

    **Output**
        | Type: table
        | Description: Output



Configuration
.............

    **Columns to filter by** (column)
        Columns to use as uniqueness filter.
    **Method** (method)
        Legacy: lacks support for time types and missing values are treated as NaN.
        Extended: supports time types and missing values are treated as separate a value.







Examples
........



Example flows demonstrating this node:

* :download:`UniqueTable.syx </Examples/Sympathy for Data/Data Processing/Select/UniqueTable.syx>`






Implementation
..............

.. automodule:: node_table_unique
    :noindex:

.. class:: UniqueTable
    :noindex: